


using System;
using SubSonic.Schema;
using System.Collections.Generic;
using SubSonic.DataProviders;
using System.Data;

namespace SurveyTracker.Data {
	
        /// <summary>
        /// Table: Mailing
        /// Primary Key: 
        /// </summary>

        public class MailingTable: DatabaseTable {
            
            public MailingTable(IDataProvider provider):base("Mailing",provider){
                ClassName = "Mailing";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("MailingID", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MailingName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100
                });

                Columns.Add(new DatabaseColumn("MailingDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MailingSubject", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });

                Columns.Add(new DatabaseColumn("MailingAuthor", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("MailingFromEmail", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100
                });

                Columns.Add(new DatabaseColumn("MailingReplyToEmail", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100
                });

                Columns.Add(new DatabaseColumn("MailingText", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1073741823
                });

                Columns.Add(new DatabaseColumn("MailingSurveyLink", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 255
                });
                    
                
                
            }

            public IColumn MailingID{
                get{
                    return this.GetColumn("MailingID");
                }
            }
				
   			public static string MailingIDColumn{
			      get{
        			return "MailingID";
      			}
		    }
            
            public IColumn MailingName{
                get{
                    return this.GetColumn("MailingName");
                }
            }
				
   			public static string MailingNameColumn{
			      get{
        			return "MailingName";
      			}
		    }
            
            public IColumn MailingDate{
                get{
                    return this.GetColumn("MailingDate");
                }
            }
				
   			public static string MailingDateColumn{
			      get{
        			return "MailingDate";
      			}
		    }
            
            public IColumn MailingSubject{
                get{
                    return this.GetColumn("MailingSubject");
                }
            }
				
   			public static string MailingSubjectColumn{
			      get{
        			return "MailingSubject";
      			}
		    }
            
            public IColumn MailingAuthor{
                get{
                    return this.GetColumn("MailingAuthor");
                }
            }
				
   			public static string MailingAuthorColumn{
			      get{
        			return "MailingAuthor";
      			}
		    }
            
            public IColumn MailingFromEmail{
                get{
                    return this.GetColumn("MailingFromEmail");
                }
            }
				
   			public static string MailingFromEmailColumn{
			      get{
        			return "MailingFromEmail";
      			}
		    }
            
            public IColumn MailingReplyToEmail{
                get{
                    return this.GetColumn("MailingReplyToEmail");
                }
            }
				
   			public static string MailingReplyToEmailColumn{
			      get{
        			return "MailingReplyToEmail";
      			}
		    }
            
            public IColumn MailingText{
                get{
                    return this.GetColumn("MailingText");
                }
            }
				
   			public static string MailingTextColumn{
			      get{
        			return "MailingText";
      			}
		    }
            
            public IColumn MailingSurveyLink{
                get{
                    return this.GetColumn("MailingSurveyLink");
                }
            }
				
   			public static string MailingSurveyLinkColumn{
			      get{
        			return "MailingSurveyLink";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: MailingHistory
        /// Primary Key: 
        /// </summary>

        public class MailingHistoryTable: DatabaseTable {
            
            public MailingHistoryTable(IDataProvider provider):base("MailingHistory",provider){
                ClassName = "MailingHistory";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("MailingListId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MailingId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ListId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("MailingDate", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("emailId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Status", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("emailHashKey", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100
                });
                    
                
                
            }

            public IColumn MailingListId{
                get{
                    return this.GetColumn("MailingListId");
                }
            }
				
   			public static string MailingListIdColumn{
			      get{
        			return "MailingListId";
      			}
		    }
            
            public IColumn MailingId{
                get{
                    return this.GetColumn("MailingId");
                }
            }
				
   			public static string MailingIdColumn{
			      get{
        			return "MailingId";
      			}
		    }
            
            public IColumn ListId{
                get{
                    return this.GetColumn("ListId");
                }
            }
				
   			public static string ListIdColumn{
			      get{
        			return "ListId";
      			}
		    }
            
            public IColumn MailingDate{
                get{
                    return this.GetColumn("MailingDate");
                }
            }
				
   			public static string MailingDateColumn{
			      get{
        			return "MailingDate";
      			}
		    }
            
            public IColumn emailId{
                get{
                    return this.GetColumn("emailId");
                }
            }
				
   			public static string emailIdColumn{
			      get{
        			return "emailId";
      			}
		    }
            
            public IColumn Status{
                get{
                    return this.GetColumn("Status");
                }
            }
				
   			public static string StatusColumn{
			      get{
        			return "Status";
      			}
		    }
            
            public IColumn emailHashKey{
                get{
                    return this.GetColumn("emailHashKey");
                }
            }
				
   			public static string emailHashKeyColumn{
			      get{
        			return "emailHashKey";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: EmailList
        /// Primary Key: 
        /// </summary>

        public class EmailListTable: DatabaseTable {
            
            public EmailListTable(IDataProvider provider):base("EmailList",provider){
                ClassName = "EmailList";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("EmailListId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("EmailId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("ListId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("status", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }

            public IColumn EmailListId{
                get{
                    return this.GetColumn("EmailListId");
                }
            }
				
   			public static string EmailListIdColumn{
			      get{
        			return "EmailListId";
      			}
		    }
            
            public IColumn EmailId{
                get{
                    return this.GetColumn("EmailId");
                }
            }
				
   			public static string EmailIdColumn{
			      get{
        			return "EmailId";
      			}
		    }
            
            public IColumn ListId{
                get{
                    return this.GetColumn("ListId");
                }
            }
				
   			public static string ListIdColumn{
			      get{
        			return "ListId";
      			}
		    }
            
            public IColumn status{
                get{
                    return this.GetColumn("status");
                }
            }
				
   			public static string statusColumn{
			      get{
        			return "status";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Emails
        /// Primary Key: 
        /// </summary>

        public class EmailsTable: DatabaseTable {
            
            public EmailsTable(IDataProvider provider):base("Emails",provider){
                ClassName = "Email";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("emailId", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("emailAddress", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100
                });

                Columns.Add(new DatabaseColumn("emailStatus", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });
                    
                
                
            }

            public IColumn emailId{
                get{
                    return this.GetColumn("emailId");
                }
            }
				
   			public static string emailIdColumn{
			      get{
        			return "emailId";
      			}
		    }
            
            public IColumn emailAddress{
                get{
                    return this.GetColumn("emailAddress");
                }
            }
				
   			public static string emailAddressColumn{
			      get{
        			return "emailAddress";
      			}
		    }
            
            public IColumn emailStatus{
                get{
                    return this.GetColumn("emailStatus");
                }
            }
				
   			public static string emailStatusColumn{
			      get{
        			return "emailStatus";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Lists
        /// Primary Key: 
        /// </summary>

        public class ListsTable: DatabaseTable {
            
            public ListsTable(IDataProvider provider):base("Lists",provider){
                ClassName = "List";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("ListID", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("listName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });
                    
                
                
            }

            public IColumn ListID{
                get{
                    return this.GetColumn("ListID");
                }
            }
				
   			public static string ListIDColumn{
			      get{
        			return "ListID";
      			}
		    }
            
            public IColumn listName{
                get{
                    return this.GetColumn("listName");
                }
            }
				
   			public static string listNameColumn{
			      get{
        			return "listName";
      			}
		    }
            
                    
        }
        
}